﻿CREATE TABLE [dbo].[ASMS_Material]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[Code] nvarchar(32) NOT NULL,
	[BusinessId] uniqueidentifier,
	[StationId] uniqueidentifier,
	[Name] nvarchar(64) NOT NULL,
	[Pinyin] nvarchar(64),
	[Letter] nvarchar(16),
	[Price] money NOT NULL,
	[Cost] money NOT NULL,
	[Category] nvarchar(32) NOT NULL,
	[Brand] nvarchar(32) NULL,
	[Unit] nvarchar(32) NULL,
	[Model] nvarchar(64),
	[QuickCode] nvarchar(64),
	[Barcode] nvarchar(64),
	[TaxRate] money NOT NULL,
	[SalesCommission] money,
	[SalesCommissionType] int,
	[Description] nvarchar(256),
	[Status] int NOT NULL,
	[CreatedTime] datetime NOT NULL,
	[Creator] nvarchar(64) NOT NULL
)
